<html>
<head>
</head>
<body>
<div style="background-color:#FFFFCC;padding:10px;border-width: 1px;border-style: solid;font-style: normal;border-color:gray;padding-top:1px;padding-bottom:1px;">
<p><b><u>TYPES OF  LOGIC UNION :</u></b></p>
<p><b>AND:</b><span id="result_box" lang="en"> The logical union 'AND' work by joining two or more filters when when conditions between these filters are met in each.</span></p>
<p><b>OR:</b><span class="conte"> The logical union 'OR' <span id="result_box" lang="en">works by joining two or more filters when the conditions between these filters are met in at least one</span>.</span><br>
<p><b><u><span id="result_box" lang="en">TYPES OF OPERATORS FOR A FILTER</span>:</u></b></p>
<p><b>LIKE:</b><span class="conte"><span id="result_box" lang="en">The like operator works exclusively with fields of type string to find matches for the search text in the column to be affected. You can use the wildcard '%' to facilitate searching. The wildcard '%' works as follows: (% abc) to coincide at the end of the field abc (abc%) to coincide abc at the beginning of the field (% abc%) Find the match anywhere in the abc field where the field also refers to the affected column</span>.</span></p>
<p><b>IN: </b><span class="conte"><span id="result_box" lang="en">The IN operator is a special type of operator that searches multiple values &#8203;&#8203;in a selected field. This operator can work with fields string and numeric types. To use it we can do as follows, for example find records that contain the data given column 1, 2 and 3, the right way to do serious writing 1,2,3 in the value field, thus the filter when applied to seek the records in the selected field are equal to 1 or 2 or 3</span>.</span></p>
<p><b>&gt; GREATER THAN TO: </b><span id="result_box" lang="en">Look for records that are greater than written value and only works with fields of type numeric.</span></p>
<p><b>&gt;= GREATER THAN OR EQUAL TO: </b><span id="result_box" lang="en"></span>Looking for records that are greater than or equal to the value written and only works with numeric type fields.</p>
<p><b>= EQUAL:</b> Find records that are equal to the value written and works with fields of type numeric or string type.</p>
<p><b>&lt;&gt; DIFFERENT:</b><span id="result_box" lang="en"> Find records that are different of the written value and works with fields of type numeric or string type.</span></p>
<p><b>&lt;= LESS THAN OR EQUAL TO:</b><span class="conte"> Find records that are less than or equal than writing value, only works with numeric type fields.</span></p>
<p><b>&lt; LESS THAN TO:</b><span id="result_box" lang="en"> Search records that are less than the value written and only works with numeric type fields</span>.</p>
<p><b>NOT IN: </b><span class="conte"><span id="result_box" lang="en">It is the opposite condition of IN</span>.</span></p>
<p><b>NOT LIKE: </b><span class="conte"><span id="result_box" lang="en">It is the opposite condition LIKE</span>.</span><br>
</p>
</div>
</body>
</html>